package com.cfs.daoimpl.sys;

public class COMMON_SQL {
    //销量分析数据表(NOTAX)
	public static String xlfxsjb=""+
	" SELECT RSJ.xse AS rxse, RSJ.tq_xse AS rtq_xse, RSJ.tq_xse_tb AS rtq_xse_tb, "+
			" RSJ.mle AS rmle, RSJ.tq_mle AS rtq_mle, RSJ.tq_mle_tb AS rtq_mle_tb, "+
			" RSJ.kdl AS rkdl, RSJ.tq_kdl AS rtq_kdl, RSJ.tq_kdl_tb AS rtq_kdl_tb, "+
			" YSJ.xse AS yxse, YSJ.tq_xse AS ytq_xse, YSJ.tq_xse_tb AS ytq_xse_tb, "+
			" YSJ.mle AS ymle, YSJ.tq_mle AS ytq_mle, YSJ.tq_mle_tb AS ytq_mle_tb, "+
			" YSJ.kdl AS ykdl, YSJ.tq_kdl AS ytq_kdl, YSJ.tq_kdl_tb AS ytq_kdl_tb, "+
			" NSJ.xse AS nxse, NSJ.tq_xse AS ntq_xse, NSJ.tq_xse_tb AS ntq_xse_tb, "+
			" NSJ.mle AS nmle, NSJ.tq_mle AS ntq_mle, NSJ.tq_mle_tb AS ntq_mle_tb, "+
			" NSJ.kdl AS nkdl, NSJ.tq_kdl AS ntq_kdl, NSJ.tq_kdl_tb AS ntq_kdl_tb "+
	" FROM "+
		" (select xse,tq_xse,decode(sign(tq_xse),0,'/',-1,'1',(xse-tq_xse)/tq_xse ) as tq_xse_tb,  "+
				" mle,tq_mle,decode(sign(tq_mle),0,'/',-1,'1',(mle-tq_mle)/tq_mle ) as tq_mle_tb,   "+
				" kdl,tq_kdl,decode(sign(tq_kdl),0,'/',-1,'1',(kdl-tq_kdl)/tq_kdl) as tq_kdl_tb   "+
		" from (  "+
			" select nvl(xse,0) as xse,nvl(mlv,0) as mlv,nvl(mle,0) as mle,nvl(kdl,0) as kdl from (   "+
				" select xse,mlv ,(xse*mlv) as mle from (   "+
					" select xse,decode(xse,0,0,((xse-cbe)/xse)) as mlv from (  "+
						" select sum(xse) as xse, sum(salesnum) as salesnum ,sum(cbe) as cbe from (   "+
							" select salesnum,(salesnum*pricenotax) as xse,(salesnum*costprice) as cbe from (  "+ 
								" select   "+ 
										" nvl(t.unitprice,0) as unitprice, "+  
										" nvl(t.salesnum,0) as salesnum,   "+
										" nvl(t.pricenotax,0) as pricenotax,   "+
										" nvl(t.costprice,0) as costprice   "+
								" from    ";
//	" tb_salesrec t where t.salesdate = "TO_DATE"('2014-05-01', 'yyyy-MM-dd') and t.salestype in (1,4) and t.category=13 "+
	public static String xlfxsjb1=""+
							" )  "+  
						" )  "+ 
					" )  "+    
				" )   "+ 
			" ) a ,(   "+
				" select sum(nvl(t.salesnum,0)) as kdl   "+
				" from    ";
//	" tb_salesrec t where t.salesdate = "TO_DATE"('2014-05-01', 'yyyy-MM-dd') and t.salestype in (1,4) and t.category=13
	public static String xlfxsjb2=""+	  
			" ) b   "+
		" ) e ,(   "+   
	  
	    " select nvl(tq_xse,0) as tq_xse,nvl(tq_mlv,0) as tq_mlv,nvl(tq_mle,0) as tq_mle,nvl(tq_kdl,0) as tq_kdl from (  "+
	    	" select xse as tq_xse,mlv as tq_mlv,(xse*mlv) as tq_mle from (   "+
	    		" select xse,decode(xse,0,0,((xse-cbe)/xse)) as mlv from (   "+
	    			" select sum(xse) as xse, sum(salesnum) as salesnum ,sum(cbe) as cbe from (   "+
	    				" select salesnum,(salesnum*pricenotax) as xse,(salesnum*costprice) as cbe from (   "+
	    					" select    "+
	    							" nvl(t.unitprice,0) as unitprice,   "+
	    							" nvl(t.salesnum,0) as salesnum,    "+  
	    							" nvl(t.pricenotax ,0) as pricenotax,   "+
	    							" nvl(t.costprice  ,0) as costprice   "+
	    					" from  ";
//	" tb_salesrec t where t.salesdate = "TO_DATE"('2014-05-01', 'yyyy-MM-dd') and t.salestype in (1,4) and t.category=13
	public static String xlfxsjb3=""+
	    					" )    "+
	    			" )   "+
	    		" )   "+   
	    	" )    "+
	    " ) c ,(   "+
	    	" select sum(nvl(t.salesnum,0)) as tq_kdl  "+
	    	" from  ";
//	" tb_salesrec t where t.salesdate = "TO_DATE"('2014-05-01', 'yyyy-MM-dd') and t.salestype in (1,4) and t.category=13
	public static String xlfxsjb4=""+	
	    	" ) d   "+
	    " ) f) RSJ "+

	" JOIN "+
		" (select xse,tq_xse,decode(sign(tq_xse),0,'/',-1,'1',(xse-tq_xse)/tq_xse ) as tq_xse_tb,   "+
				" mle,tq_mle,decode(sign(tq_mle),0,'/',-1,'1',(mle-tq_mle)/tq_mle ) as tq_mle_tb,   "+
				" kdl,tq_kdl,decode(sign(tq_kdl),0,'/',-1,'1',(kdl-tq_kdl)/tq_kdl) as tq_kdl_tb   "+
		" from (  "+
			" select nvl(xse,0) as xse,nvl(mlv,0) as mlv,nvl(mle,0) as mle,nvl(kdl,0) as kdl from (   "+
				" select xse,mlv ,(xse*mlv) as mle from (   "+
					" select xse,decode(xse,0,0,((xse-cbe)/xse)) as mlv from (  "+
						" select sum(xse) as xse, sum(salesnum) as salesnum ,sum(cbe) as cbe from (  "+ 
							" select salesnum,(salesnum*pricenotax) as xse,(salesnum*costprice) as cbe from (   "+
								" select    "+
										" nvl(t.unitprice,0) as unitprice,   "+
										" nvl(t.salesnum,0) as salesnum,   "+   
										" nvl(t.pricenotax,0) as pricenotax,   "+
										" nvl(t.costprice,0) as costprice   "+
								" from    ";
//	" tb_salesrec t where t.salesdate = "TO_DATE"('2014-05-01', 'yyyy-MM-dd') and t.salestype in (1,4) and t.category=13
	public static String xlfxsjb5=""+
							" )   "+ 
						" )   "+
					" )      "+
				" )    "+
			" ) a ,(  "+ 
				" select sum(nvl(t.salesnum,0)) as kdl   "+
				" from    ";
//	" tb_salesrec t where t.salesdate = "TO_DATE"('2014-05-01', 'yyyy-MM-dd') and t.salestype in (1,4) and t.category=13
	public static String xlfxsjb6=""+	  
				" ) b   "+
			" ) e ,(   "+   
	  
			" select nvl(tq_xse,0) as tq_xse,nvl(tq_mlv,0) as tq_mlv,nvl(tq_mle,0) as tq_mle,nvl(tq_kdl,0) as tq_kdl from (  "+
				" select xse as tq_xse,mlv as tq_mlv,(xse*mlv) as tq_mle from (   "+
					" select xse,decode(xse,0,0,((xse-cbe)/xse)) as mlv from (   "+
						" select sum(xse) as xse, sum(salesnum) as salesnum ,sum(cbe) as cbe from (   "+
							" select salesnum,(salesnum*pricenotax) as xse,(salesnum*costprice) as cbe from (   "+
								" select    "+
										" nvl(t.unitprice,0) as unitprice,  "+ 
										" nvl(t.salesnum,0) as salesnum,   "+   
										" nvl(t.pricenotax ,0) as pricenotax,   "+
										" nvl(t.costprice  ,0) as costprice   "+
								" from  ";
//	" tb_salesrec t where t.salesdate = "TO_DATE"('2014-05-01', 'yyyy-MM-dd') and t.salestype in (1,4) and t.category=13
	public static String xlfxsjb7=""+
								" )   "+ 
						" )   "+
					" )      "+
				" )    "+
			" ) c ,(  "+ 
				" select sum(nvl(t.salesnum,0)) as tq_kdl  "+ 
				" from  ";
//	" tb_salesrec t where t.salesdate = "TO_DATE"('2014-05-01', 'yyyy-MM-dd') and t.salestype in (1,4) and t.category=13
	public static String xlfxsjb8=""+	
				" ) d   "+
			" ) f) YSJ "+

	" ON 1=1 "+
	" JOIN "+
		" (select xse,tq_xse,decode(sign(tq_xse),0,'/',-1,'1',(xse-tq_xse)/tq_xse ) as tq_xse_tb,   "+
				" mle,tq_mle,decode(sign(tq_mle),0,'/',-1,'1',(mle-tq_mle)/tq_mle ) as tq_mle_tb,   "+
				" kdl,tq_kdl,decode(sign(tq_kdl),0,'/',-1,'1',(kdl-tq_kdl)/tq_kdl) as tq_kdl_tb   "+
		" from (  "+
			" select nvl(xse,0) as xse,nvl(mlv,0) as mlv,nvl(mle,0) as mle,nvl(kdl,0) as kdl from (   "+
				" select xse,mlv ,(xse*mlv) as mle from (   "+
					" select xse,decode(xse,0,0,((xse-cbe)/xse)) as mlv from (  "+
						" select sum(xse) as xse, sum(salesnum) as salesnum ,sum(cbe) as cbe from (  "+ 
							" select salesnum,(salesnum*pricenotax) as xse,(salesnum*costprice) as cbe from (  "+ 
								" select    "+
										" nvl(t.unitprice,0) as unitprice,   "+
										" nvl(t.salesnum,0) as salesnum,   "+   
										" nvl(t.pricenotax,0) as pricenotax,   "+
										" nvl(t.costprice,0) as costprice   "+
								" from    ";
//	" tb_salesrec t where t.salesdate = "TO_DATE"('2014-05-01', 'yyyy-MM-dd') and t.salestype in (1,4) and t.category=13
	public static String xlfxsjb9=""+
							" )  "+  
						" )   "+
					" )      "+
				" )    "+
			" ) a ,(  "+ 
				" select sum(nvl(t.salesnum,0)) as kdl   "+
				" from    ";
//	" tb_salesrec t where t.salesdate = "TO_DATE"('2014-05-01', 'yyyy-MM-dd') and t.salestype in (1,4) and t.category=13
	public static String xlfxsjb10=""+  
				" ) b   "+
			" ) e ,(    "+
			" select nvl(tq_xse,0) as tq_xse,nvl(tq_mlv,0) as tq_mlv,nvl(tq_mle,0) as tq_mle,nvl(tq_kdl,0) as tq_kdl from (  "+
				" select xse as tq_xse,mlv as tq_mlv,(xse*mlv) as tq_mle from (   "+
					" select xse,decode(xse,0,0,((xse-cbe)/xse)) as mlv from (   "+
						" select sum(xse) as xse, sum(salesnum) as salesnum ,sum(cbe) as cbe from (   "+
							" select salesnum,(salesnum*pricenotax) as xse,(salesnum*costprice) as cbe from (   "+
								" select  "+  
										" nvl(t.unitprice,0) as unitprice,  "+ 
										" nvl(t.salesnum,0) as salesnum,    "+  
										" nvl(t.pricenotax ,0) as pricenotax,  "+ 
										" nvl(t.costprice  ,0) as costprice   "+
								" from  ";
//	" tb_salesrec t where t.salesdate = "TO_DATE"('2014-05-01', 'yyyy-MM-dd') and t.salestype in (1,4) and t.category=13
	public static String xlfxsjb11=""+
								" ) "+   
						" )   "+
					" )      "+
				" )    "+
			" ) c ,(  "+ 
				" select sum(nvl(t.salesnum,0)) as tq_kdl  "+
				" from  ";
//	" tb_salesrec t where t.salesdate = "TO_DATE"('2014-05-01', 'yyyy-MM-dd') and t.salestype in (1,4) and t.category=13
	public static String xlfxsjb12=""+	
				" ) d   "+
			" ) f) NSJ "+
	" ON 1=1";
	
	public static String pricenotax= "nvl(t.pricenotax,0) as pricenotax,";
	public static String supplyprice= "nvl(t.supplyprice,0) as pricenotax,";
	
	//销量分析数据表(supplyprice)
	public static String xlfxsjb_S=""+
	" SELECT RSJ.xse AS rxse, RSJ.tq_xse AS rtq_xse, RSJ.tq_xse_tb AS rtq_xse_tb, "+
			" RSJ.mle AS rmle, RSJ.tq_mle AS rtq_mle, RSJ.tq_mle_tb AS rtq_mle_tb, "+
			" RSJ.kdl AS rkdl, RSJ.tq_kdl AS rtq_kdl, RSJ.tq_kdl_tb AS rtq_kdl_tb, "+
			" YSJ.xse AS yxse, YSJ.tq_xse AS ytq_xse, YSJ.tq_xse_tb AS ytq_xse_tb, "+
			" YSJ.mle AS ymle, YSJ.tq_mle AS ytq_mle, YSJ.tq_mle_tb AS ytq_mle_tb, "+
			" YSJ.kdl AS ykdl, YSJ.tq_kdl AS ytq_kdl, YSJ.tq_kdl_tb AS ytq_kdl_tb, "+
			" NSJ.xse AS nxse, NSJ.tq_xse AS ntq_xse, NSJ.tq_xse_tb AS ntq_xse_tb, "+
			" NSJ.mle AS nmle, NSJ.tq_mle AS ntq_mle, NSJ.tq_mle_tb AS ntq_mle_tb, "+
			" NSJ.kdl AS nkdl, NSJ.tq_kdl AS ntq_kdl, NSJ.tq_kdl_tb AS ntq_kdl_tb "+
	" FROM "+
		" (select xse,tq_xse,decode(sign(tq_xse),0,'/',-1,'1',(xse-tq_xse)/tq_xse ) as tq_xse_tb,  "+
				" mle,tq_mle,decode(sign(tq_mle),0,'/',-1,'1',(mle-tq_mle)/tq_mle ) as tq_mle_tb,   "+
				" kdl,tq_kdl,decode(sign(tq_kdl),0,'/',-1,'1',(kdl-tq_kdl)/tq_kdl) as tq_kdl_tb   "+
		" from (  "+
			" select nvl(xse,0) as xse,nvl(mlv,0) as mlv,nvl(mle,0) as mle,nvl(kdl,0) as kdl from (   "+
				" select xse,mlv ,(xse*mlv) as mle from (   "+
					" select xse,decode(xse,0,0,((xse-cbe)/xse)) as mlv from (  "+
						" select sum(xse) as xse, sum(salesnum) as salesnum ,sum(cbe) as cbe from (   "+
							" select salesnum,(salesnum*pricenotax) as xse,(salesnum*costprice) as cbe from (  "+ 
								" select   "+ 
										" nvl(t.unitprice,0) as unitprice, "+  
										" nvl(t.salesnum,0) as salesnum,   "+
										" nvl(t.supplyprice,0) as pricenotax,   "+
										" nvl(t.costprice,0) as costprice   "+
								" from    ";
//	" tb_salesrec t where t.salesdate = "TO_DATE"('2014-05-01', 'yyyy-MM-dd') and t.salestype in (1,4) and t.category=13 "+
	public static String xlfxsjb1_S=""+
							" )  "+  
						" )  "+ 
					" )  "+    
				" )   "+ 
			" ) a ,(   "+
				" select sum(nvl(t.salesnum,0)) as kdl   "+
				" from    ";
//	" tb_salesrec t where t.salesdate = "TO_DATE"('2014-05-01', 'yyyy-MM-dd') and t.salestype in (1,4) and t.category=13
	public static String xlfxsjb2_S=""+	  
			" ) b   "+
		" ) e ,(   "+   
	  
	    " select nvl(tq_xse,0) as tq_xse,nvl(tq_mlv,0) as tq_mlv,nvl(tq_mle,0) as tq_mle,nvl(tq_kdl,0) as tq_kdl from (  "+
	    	" select xse as tq_xse,mlv as tq_mlv,(xse*mlv) as tq_mle from (   "+
	    		" select xse,decode(xse,0,0,((xse-cbe)/xse)) as mlv from (   "+
	    			" select sum(xse) as xse, sum(salesnum) as salesnum ,sum(cbe) as cbe from (   "+
	    				" select salesnum,(salesnum*pricenotax) as xse,(salesnum*costprice) as cbe from (   "+
	    					" select    "+
	    							" nvl(t.unitprice,0) as unitprice,   "+
	    							" nvl(t.salesnum,0) as salesnum,    "+  
	    							" nvl(t.supplyprice ,0) as pricenotax,   "+
	    							" nvl(t.costprice  ,0) as costprice   "+
	    					" from  ";
//	" tb_salesrec t where t.salesdate = "TO_DATE"('2014-05-01', 'yyyy-MM-dd') and t.salestype in (1,4) and t.category=13
	public static String xlfxsjb3_S=""+
	    					" )    "+
	    			" )   "+
	    		" )   "+   
	    	" )    "+
	    " ) c ,(   "+
	    	" select sum(nvl(t.salesnum,0)) as tq_kdl  "+
	    	" from  ";
//	" tb_salesrec t where t.salesdate = "TO_DATE"('2014-05-01', 'yyyy-MM-dd') and t.salestype in (1,4) and t.category=13
	public static String xlfxsjb4_S=""+	
	    	" ) d   "+
	    " ) f) RSJ "+

	" JOIN "+
		" (select xse,tq_xse,decode(sign(tq_xse),0,'/',-1,'1',(xse-tq_xse)/tq_xse ) as tq_xse_tb,   "+
				" mle,tq_mle,decode(sign(tq_mle),0,'/',-1,'1',(mle-tq_mle)/tq_mle ) as tq_mle_tb,   "+
				" kdl,tq_kdl,decode(sign(tq_kdl),0,'/',-1,'1',(kdl-tq_kdl)/tq_kdl) as tq_kdl_tb   "+
		" from (  "+
			" select nvl(xse,0) as xse,nvl(mlv,0) as mlv,nvl(mle,0) as mle,nvl(kdl,0) as kdl from (   "+
				" select xse,mlv ,(xse*mlv) as mle from (   "+
					" select xse,decode(xse,0,0,((xse-cbe)/xse)) as mlv from (  "+
						" select sum(xse) as xse, sum(salesnum) as salesnum ,sum(cbe) as cbe from (  "+ 
							" select salesnum,(salesnum*pricenotax) as xse,(salesnum*costprice) as cbe from (   "+
								" select    "+
										" nvl(t.unitprice,0) as unitprice,   "+
										" nvl(t.salesnum,0) as salesnum,   "+   
										" nvl(t.supplyprice,0) as pricenotax,   "+
										" nvl(t.costprice,0) as costprice   "+
								" from    ";
//	" tb_salesrec t where t.salesdate = "TO_DATE"('2014-05-01', 'yyyy-MM-dd') and t.salestype in (1,4) and t.category=13
	public static String xlfxsjb5_S=""+
							" )   "+ 
						" )   "+
					" )      "+
				" )    "+
			" ) a ,(  "+ 
				" select sum(nvl(t.salesnum,0)) as kdl   "+
				" from    ";
//	" tb_salesrec t where t.salesdate = "TO_DATE"('2014-05-01', 'yyyy-MM-dd') and t.salestype in (1,4) and t.category=13
	public static String xlfxsjb6_S=""+	  
				" ) b   "+
			" ) e ,(   "+   
	  
			" select nvl(tq_xse,0) as tq_xse,nvl(tq_mlv,0) as tq_mlv,nvl(tq_mle,0) as tq_mle,nvl(tq_kdl,0) as tq_kdl from (  "+
				" select xse as tq_xse,mlv as tq_mlv,(xse*mlv) as tq_mle from (   "+
					" select xse,decode(xse,0,0,((xse-cbe)/xse)) as mlv from (   "+
						" select sum(xse) as xse, sum(salesnum) as salesnum ,sum(cbe) as cbe from (   "+
							" select salesnum,(salesnum*pricenotax) as xse,(salesnum*costprice) as cbe from (   "+
								" select    "+
										" nvl(t.unitprice,0) as unitprice,  "+ 
										" nvl(t.salesnum,0) as salesnum,   "+   
										" nvl(t.supplyprice ,0) as pricenotax,   "+
										" nvl(t.costprice  ,0) as costprice   "+
								" from  ";
//	" tb_salesrec t where t.salesdate = "TO_DATE"('2014-05-01', 'yyyy-MM-dd') and t.salestype in (1,4) and t.category=13
	public static String xlfxsjb7_S=""+
								" )   "+ 
						" )   "+
					" )      "+
				" )    "+
			" ) c ,(  "+ 
				" select sum(nvl(t.salesnum,0)) as tq_kdl  "+ 
				" from  ";
//	" tb_salesrec t where t.salesdate = "TO_DATE"('2014-05-01', 'yyyy-MM-dd') and t.salestype in (1,4) and t.category=13
	public static String xlfxsjb8_S=""+	
				" ) d   "+
			" ) f) YSJ "+

	" ON 1=1 "+
	" JOIN "+
		" (select xse,tq_xse,decode(sign(tq_xse),0,'/',-1,'1',(xse-tq_xse)/tq_xse ) as tq_xse_tb,   "+
				" mle,tq_mle,decode(sign(tq_mle),0,'/',-1,'1',(mle-tq_mle)/tq_mle ) as tq_mle_tb,   "+
				" kdl,tq_kdl,decode(sign(tq_kdl),0,'/',-1,'1',(kdl-tq_kdl)/tq_kdl) as tq_kdl_tb   "+
		" from (  "+
			" select nvl(xse,0) as xse,nvl(mlv,0) as mlv,nvl(mle,0) as mle,nvl(kdl,0) as kdl from (   "+
				" select xse,mlv ,(xse*mlv) as mle from (   "+
					" select xse,decode(xse,0,0,((xse-cbe)/xse)) as mlv from (  "+
						" select sum(xse) as xse, sum(salesnum) as salesnum ,sum(cbe) as cbe from (  "+ 
							" select salesnum,(salesnum*pricenotax) as xse,(salesnum*costprice) as cbe from (  "+ 
								" select    "+
										" nvl(t.unitprice,0) as unitprice,   "+
										" nvl(t.salesnum,0) as salesnum,   "+   
										" nvl(t.supplyprice,0) as pricenotax,   "+
										" nvl(t.costprice,0) as costprice   "+
								" from    ";
//	" tb_salesrec t where t.salesdate = "TO_DATE"('2014-05-01', 'yyyy-MM-dd') and t.salestype in (1,4) and t.category=13
	public static String xlfxsjb9_S=""+
							" )  "+  
						" )   "+
					" )      "+
				" )    "+
			" ) a ,(  "+ 
				" select sum(nvl(t.salesnum,0)) as kdl   "+
				" from    ";
//	" tb_salesrec t where t.salesdate = "TO_DATE"('2014-05-01', 'yyyy-MM-dd') and t.salestype in (1,4) and t.category=13
public static String xlfxsjb10_S=""+	  
				" ) b   "+
			" ) e ,(    "+  
			" select nvl(tq_xse,0) as tq_xse,nvl(tq_mlv,0) as tq_mlv,nvl(tq_mle,0) as tq_mle,nvl(tq_kdl,0) as tq_kdl from (  "+
				" select xse as tq_xse,mlv as tq_mlv,(xse*mlv) as tq_mle from (   "+
					" select xse,decode(xse,0,0,((xse-cbe)/xse)) as mlv from (   "+
						" select sum(xse) as xse, sum(salesnum) as salesnum ,sum(cbe) as cbe from (   "+
							" select salesnum,(salesnum*pricenotax) as xse,(salesnum*costprice) as cbe from (   "+
								" select  "+  
										" nvl(t.unitprice,0) as unitprice,  "+ 
										" nvl(t.salesnum,0) as salesnum,    "+  
										" nvl(t.supplyprice ,0) as pricenotax,  "+ 
										" nvl(t.costprice  ,0) as costprice   "+
								" from  ";
//	" tb_salesrec t where t.salesdate = "TO_DATE"('2014-05-01', 'yyyy-MM-dd') and t.salestype in (1,4) and t.category=13
	public static String xlfxsjb11_S=""+
								" ) "+   
						" )   "+
					" )      "+
				" )    "+
			" ) c ,(  "+ 
				" select sum(nvl(t.salesnum,0)) as tq_kdl  "+
				" from  ";
//	" tb_salesrec t where t.salesdate = "TO_DATE"('2014-05-01', 'yyyy-MM-dd') and t.salestype in (1,4) and t.category=13
	public static String xlfxsjb12_S=""+	
				" ) d   "+
			" ) f) NSJ "+
	" ON 1=1";
	
}
